Referencing Cells and Columns in Formulas

The way you reference cells and columns in a formula depends on the current column notation: alphabetic or numeric.

• Reference a cell in a formula by its column ID and row position (C6R13 if the column ID is numeric or F13 if the column ID is alphabetic).

Important! You cannot mix numeric and alphabetic cell/column references in a formula.
 
• Reference a column in a formula by its column ID, whether alphabetic (A–ALL) or numeric (C1–C1000).

When column notation is alphabetic, you reference a column by character. For example, you would reference column 26 as Z, column 28 as AB, and so on. When column notation is numeric, you must prefix each column number by the letter C. For example, you would reference column 3 as C3 and column 125 as C125.

Note: Remember that column notation can be changed in the Data Window Options dialog.

Referencing a Range of Cells or Columns
To reference a range, enter the first cell/column, a colon (:), then the last cell/column in the range.
For example, to specify the sum of the values in a range from row 10 to row 16 of column 5, enter =SUM(C5R10:C5R16) if the column ID is numeric or =SUM(E10:E16) if the ID is alphabetic.

See also:
Data Window, Customizing

End of Topic